﻿-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE PROCEDURE UpdateProfileViewInterest 
	@ProfileID bigint,
	@ReligionView varchar(200),
	@ReligionViewPrivacy smallint,
	@PoliticalView varchar(200),
	@PoliticalViewPrivacy smallint,
	@PeopleInspired varchar(200),
	@PeopleInspiredPrivacy smallint,
	@FavQuote varchar(200),
	@FavQuotePrivacy smallint,
	@HobbiesInterest varchar(200),
	@HobbiesInterestPrivacy smallint
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

    UPDATE ProfileInfo
    SET ReligionView=@ReligionView,
    ReligionViewPrivacy=@ReligionViewPrivacy,
    PoliticalView=@PoliticalView,
    PoliticalViewPrivacy=@PoliticalViewPrivacy,
    PeopleInspired=@PeopleInspired,
    PeopleInspiredPrivacy=@PeopleInspiredPrivacy,
    FavQuote=@FavQuote,
    FavQuotePrivacy=@FavQuotePrivacy,
    HobbiesInterest=@HobbiesInterest,
    HobbiesInterestPrivacy=@HobbiesInterestPrivacy,
    ModifiedDate=GETDATE()
    WHERE ProfileID=@ProfileID
END


